import sqlite3


import os
os.remove('/tmp/test.sqlite')

conn = sqlite3.connect('/tmp/test.sqlite')
c = conn.cursor()

c.execute('create table test (value DECIMAL )')

line = float('123.34')

c.execute('insert into test values (?)', [line])

conn.commit()

rows = c.execute('select * from test')
for row in rows:
    print row

c.close()
